SHOW-CATALOGS

SHOW-CATALOGS

Name

SHOW CATALOGS

Description

This statement is used to view created catalogs

Syntax:

SHOW CATALOGS

Return result description:

• CatalogId: Unique ID of the catalog
• CatalogName: Catalog name. where "internal" is the default built-in catalog, which cannot be modified.
• Type: Catalog type.

Example

1. View all created catalogs

   SHOW CATALOGS;
    +-----------+-------------+----------+
    | CatalogId | CatalogName | Type     |
    +-----------+-------------+----------+
    |     10024 | hive        | hms      |
    |         0 | internal    | internal |
    +-----------+-------------+----------+

Keywords

SHOW, CATALOG, CATALOGS

Best Practice